/*
 *  Copyright (C) 2010 Fabien Renaud
 * 
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 * 
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 * 
 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package com.boc.botv.dao.impl;

import com.boc.botv.common.Database;
import com.boc.botv.dao.BetChoiceDao;
import com.boc.botv.model.BetChoice;
import java.util.List;
import org.springframework.stereotype.Repository;

/**
 *
 * @author Fabien Renaud
 */
@Repository("betChoiceDao")
public class BetChoiceDaoImpl implements BetChoiceDao {

  public BetChoice getChoice(int choiceId) {
    return (BetChoice) Database.getSession().load(BetChoice.class, choiceId);
  }

  public List<BetChoice> getChoices(int betId) {
    return (List<BetChoice>) Database.getSession().createQuery("from BetChoice as bc where bc.bet=" + betId).list();
  }

  public void saveChoice(BetChoice betChoice) {
    Database.getSession().save(betChoice);
  }

  public void deleteChoice(BetChoice betChoice) {
    Database.getSession().delete(betChoice);
  }

  public void updateChoice(BetChoice betChoice) {
    Database.getSession().update(betChoice);
  }

  public BetChoice getWinningChoice(int betId) {
    List<BetChoice> bcl = (List<BetChoice>) Database.getSession().createQuery("from BetChoice as bc where bc.isWinning=1 and bc.bet=" + betId);
    if (bcl.size() != 1) {
      return null;
    }
    return bcl.get(0);
  }

  public List<BetChoice> getLosingChoices(int betId) {
    return (List<BetChoice>) Database.getSession().createQuery("from BetChoice as bc where bc.isWinning=0 and bc.bet=" + betId).list();
  }
}
